package com.lokyiu.mybible.db.sqlite.def;

import android.database.sqlite.SQLiteDatabase;

public class BookColumns implements Columns {

	/**
	 * ------------- BOOK Table
	 */
	// TABLE NAME
	public static final String TABLENAME = "biblebooks";
	//COLUMN NAMES
	public static final String BOOK_NAME = "name";
	public static final String BOOK_URL = "url";
	// CREATE SQL
	public static final String CREATE_BOOKS_TABLE_SQL = "create table " + TABLENAME + "(" 
												+ BOOK_NAME + " TEXT primary key," 
												+ BOOK_URL  + " TEXT "
												+ ")";

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(CREATE_BOOKS_TABLE_SQL);
	}

	@Override
	public void dropTable(SQLiteDatabase db) {
		db.execSQL("DROP TABLE IF EXISTS " + TABLENAME);
	}

	@Override
	public String getTableName() {
		return TABLENAME;
	}

}
